Data Modeling

supOS uses UNS (Unified Namespace) to organize data into a clear, tree-like structure. Each folder and file in the model automatically generates an MQTT topic, making it easy to get real-time data.

Things to Notice before Start

Page Overview

Select UNS > Namespace after logging in to supOS, you will see the main page of this module.

No.	Item	Description
1	Model	Tree view of data models already built in UNS
	Template	Tree view of data model templates already built in UNS
	Label	Displays labels, and models under each label
2		Displays data models by category: Text/Template/Label.
	/	Search data models / Refresh data model list.
	/	Create folder-file structured data models based on data hierarchy.
		Create data models by manually inputting JSON.
3	Raw Topics	Lists the topics received in the internal broker, which can be transformed to data models. For details, see Building Models through MQTT.
4	Overview	Comprehensive view of existing folders and files, and the number of connections between data sources and the internal MQTT broker
5	Topology Map	Visualizes the data flow using a topology diagram
6	Import/Export	Import/export data models in JSON or Excel format

Extra Parameter Definition

• Folder

Item	Description
Extended Info	Add extended information for the folder. Eg. unit.
Template	Select a template to inherit attributes from it. See Building Template.
Generate Template	Click to add an attribute to the folder, at the same time you can select to generate a same template for future use.

• File-Data Type

Type	Description
Time Series	Receive real-time data and store it in TDEngine.
Relational	Receive relational data and store it in a Postgres database.
Calculation	Perform basic calculations on the added time series attributes.
Aggregation	Aggregate the added data sources into JSON at a fixed frequency.
Reference	Select an existing file and copy its attributes.

• File-Attribute Generation Method

Attribute Generation Method	Description
Custom	Customize attributes.
Template	Inherit attributes from the selected template.
Reverse Generation	Use JSON text or connected databases to generate attributes with the same structure.

info

You can connect databases under DevTools > DBConnect. For details, see Database Connection.

• File-Linked Operation

Item	Description
Persistence	Enable historical data storage for the selected file.
Mock Data	Generates a data flow with mock data in UNS > SourceFlow.
Auto-Dashboard	Generates a dashboard in System > Dashboards.

How to Build a Data Model

Based on simple folder-file structure, you can define the data hierarchy to a tree map.

Building Models Manually

note

Factory/workshop/equipment/CNC will be used as an example, in which Factory, workshop and equipment are folders and CNC is a file.

1. Log in to supOS, and then select UNS > Namespace.
2. Under Model, click to add a folder (e.g. factory).

3. Select equipment, and then click to add a file (e.g.CNC) under it.

4. Enter the information of the file based on the data tag, and then click Next.
5. Select Persistance to enable history data storage, and then click Save.

Generating Models through JSON

1. Log in to supOS, and then select UNS > Namespace.
2. Click on the Model page.

3. Select the data type, and then write JSON text for the model according to the data tree structure.

{
    "Factory1": {
        "workshop1": {
            "equipment1": {
                "CNC1": [
                    {
                        "actualRuntime1": 1380,
                        "plannedRuntime1": 1440
                    }
                ]
            }
        }
    }
}

4. Click Next, and select the model on the left side.

tip

Click on each data level, you can change its information and add attributes on the right side.

5. Click Save.

Building Models through MQTT

1. Use an MQTT client to connect to the internal broker of supOS-CE.

• Host: Your supOS-CE domain.
• Port: 1883.

2. Define a topic and message payload on the client, and then send it to supOS.

3. Log in to supOS, and then select UNS > Namespace.
4. Expand Raw Topics, find the topic you defined.
5. Click Topic to File icon next to the topic, and then edit the file and complete the namespace creation.

Importing Models

1. Log in to supOS, and then select UNS > Namespace.
2. Click Import at the upper-right corner, and then click Download Template.

3. Fill in the template table.

tip

You can manually add a folder and file, export it and use it as an example for import.

4. Save the template table, and then click Import on the Namespace page.
5. Select the template, and then click Save.

Optional Features

Building Template

1. On the Namespace page, click Template.
2. Click , and then enter the information of the template.

tip

Click Source to select added models and inherit their attributes.

3. Click Save.

Creating Label

Labels are used for categorizing data models.

1. On the Namespace page, click Label.
2. Click , and then enter the label name.
3. Click Save, and then click to add files under the label.

4. Click Save.